<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace='CheckListH' xmlns='http://ibatis.apache.org/mapping' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'>
  <alias>
    <typeAlias alias='CheckListH' assembly='Janus.Mes.POCO.dll' type='Janus.Mes.POCO.CheckListH' />
  </alias>
  <resultMaps>
    <resultMap id='CheckListHResult' class='CheckListH'>
	<result property='Id' column='Id' /> 
	<result property='CheckNo' column='CheckNo' /> 
	<result property='CheckType' column='CheckType' /> 
	<result property='StartDate' column='StartDate' /> 
	<result property='EndDate' column='EndDate' /> 
	<result property='InvCode' column='InvCode' /> 
	<result property='BatchQty' column='BatchQty' /> 
	<result property='SampType' column='SampType' /> 
	<result property='CustSampCode' column='CustSampCode' /> 
	<result property='Percentage' column='Percentage' /> 
	<result property='SampQty' column='SampQty' /> 
	<result property='CheckLevel' column='CheckLevel' /> 
	<result property='StrictDegree' column='StrictDegree' /> 
	<result property='AQL' column='AQL' /> 
	<result property='RecQty' column='RecQty' /> 
	<result property='RejectionQty' column='RejectionQty' /> 
	<result property='MoCode' column='MoCode' /> 
	<result property='MoSeq' column='MoSeq' /> 
	<result property='SchCode' column='SchCode' /> 
	<result property='ProcCode' column='ProcCode' /> 
	<result property='WorkNo' column='WorkNo' /> 
	<result property='ShiftCode' column='ShiftCode' /> 
	<result property='IssNo' column='IssNo' /> 
	<result property='IssSeq' column='IssSeq' /> 
	<result property='Remark' column='Remark' /> 
	<result property='QualifiedQty' column='QualifiedQty' /> 
	<result property='QualWh' column='QualWh' /> 
	<result property='ProcUnQty' column='ProcUnQty' /> 
	<result property='ProcUnWh' column='ProcUnWh' /> 
	<result property='IssUnQty' column='IssUnQty' /> 
	<result property='IssUnWh' column='IssUnWh' /> 
	<result property='QualSampQty' column='QualSampQty' /> 
	<result property='QualSampWh' column='QualSampWh' /> 
	<result property='UnQualSampQty' column='UnQualSampQty' /> 
	<result property='UnQualSampWh' column='UnQualSampWh' /> 
	<result property='Checker' column='Checker' /> 
	<result property='CheckDept' column='CheckDept' /> 
	<result property='Result' column='Result' /> 
	<result property='State' column='State' /> 
	<result property='Creator' column='Creator' /> 
	<result property='CreateDate' column='CreateDate' /> 
	<result property='Updater' column='Updater' /> 
	<result property='UpdateDate' column='UpdateDate' /> 
	<result property='IsDelete' column='IsDelete' /> 
	<result property='CreatorCode' column='CreatorCode' /> 
	<result property='UpdaterCode' column='UpdaterCode' /> 
	<result property='OperDept' column='OperDept' /> 
	<result property='Timestamp' column='Timestamp' /> 
		</resultMap>
  </resultMaps>  
  <statements>
  <sql id="UpdaterConditions">  
  <dynamic prepend="SET">
        	<isPropertyAvailable prepend="" property="CheckType">
        <isNotEmpty prepend="," property="CheckType">
		          [CheckType]=#CheckType#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="StartDate">
        <isNotEmpty prepend="," property="StartDate">
		          [StartDate]=#StartDate#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="EndDate">
        <isNotEmpty prepend="," property="EndDate">
		          [EndDate]=#EndDate#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="InvCode">
        <isNotEmpty prepend="," property="InvCode">
		          [InvCode]=#InvCode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="BatchQty">
        <isNotEmpty prepend="," property="BatchQty">
		          [BatchQty]=#BatchQty#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="SampType">
        <isNotEmpty prepend="," property="SampType">
		          [SampType]=#SampType#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="CustSampCode">
        <isNotEmpty prepend="," property="CustSampCode">
		          [CustSampCode]=#CustSampCode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Percentage">
        <isNotEmpty prepend="" property="Percentage">
				  <isNotEqual prepend="," property="Percentage" compareValue="0">
		          [Percentage]=#Percentage#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="SampQty">
        <isNotEmpty prepend="" property="SampQty">
				  <isNotEqual prepend="," property="SampQty" compareValue="0">
		          [SampQty]=#SampQty#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="CheckLevel">
        <isNotEmpty prepend="," property="CheckLevel">
		          [CheckLevel]=#CheckLevel#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="StrictDegree">
        <isNotEmpty prepend="," property="StrictDegree">
		          [StrictDegree]=#StrictDegree#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="AQL">
        <isNotEmpty prepend="" property="AQL">
				  <isNotEqual prepend="," property="AQL" compareValue="0">
		          [AQL]=#AQL#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="RecQty">
        <isNotEmpty prepend="" property="RecQty">
				  <isNotEqual prepend="," property="RecQty" compareValue="((0))">
		          [RecQty]=#RecQty#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="RejectionQty">
        <isNotEmpty prepend="" property="RejectionQty">
				  <isNotEqual prepend="," property="RejectionQty" compareValue="((0))">
		          [RejectionQty]=#RejectionQty#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="MoCode">
        <isNotEmpty prepend="," property="MoCode">
		          [MoCode]=#MoCode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="MoSeq">
        <isNotEmpty prepend="," property="MoSeq">
		          [MoSeq]=#MoSeq#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="SchCode">
        <isNotEmpty prepend="," property="SchCode">
		          [SchCode]=#SchCode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="ProcCode">
        <isNotEmpty prepend="," property="ProcCode">
		          [ProcCode]=#ProcCode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="WorkNo">
        <isNotEmpty prepend="," property="WorkNo">
		          [WorkNo]=#WorkNo#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="ShiftCode">
        <isNotEmpty prepend="," property="ShiftCode">
		          [ShiftCode]=#ShiftCode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="IssNo">
        <isNotEmpty prepend="," property="IssNo">
		          [IssNo]=#IssNo#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="IssSeq">
        <isNotEmpty prepend="" property="IssSeq">
				  <isNotEqual prepend="," property="IssSeq" compareValue="0">
		          [IssSeq]=#IssSeq#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Remark">
        <isNotEmpty prepend="," property="Remark">
		          [Remark]=#Remark#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="QualifiedQty">
        <isNotEmpty prepend="" property="QualifiedQty">
				  <isNotEqual prepend="," property="QualifiedQty" compareValue="0">
		          [QualifiedQty]=#QualifiedQty#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="QualWh">
        <isNotEmpty prepend="," property="QualWh">
		          [QualWh]=#QualWh#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="ProcUnQty">
        <isNotEmpty prepend="" property="ProcUnQty">
				  <isNotEqual prepend="," property="ProcUnQty" compareValue="0">
		          [ProcUnQty]=#ProcUnQty#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="ProcUnWh">
        <isNotEmpty prepend="," property="ProcUnWh">
		          [ProcUnWh]=#ProcUnWh#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="IssUnQty">
        <isNotEmpty prepend="" property="IssUnQty">
				  <isNotEqual prepend="," property="IssUnQty" compareValue="0">
		          [IssUnQty]=#IssUnQty#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="IssUnWh">
        <isNotEmpty prepend="," property="IssUnWh">
		          [IssUnWh]=#IssUnWh#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="QualSampQty">
        <isNotEmpty prepend="" property="QualSampQty">
				  <isNotEqual prepend="," property="QualSampQty" compareValue="0">
		          [QualSampQty]=#QualSampQty#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="QualSampWh">
        <isNotEmpty prepend="," property="QualSampWh">
		          [QualSampWh]=#QualSampWh#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="UnQualSampQty">
        <isNotEmpty prepend="" property="UnQualSampQty">
				  <isNotEqual prepend="," property="UnQualSampQty" compareValue="0">
		          [UnQualSampQty]=#UnQualSampQty#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="UnQualSampWh">
        <isNotEmpty prepend="," property="UnQualSampWh">
		          [UnQualSampWh]=#UnQualSampWh#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Checker">
        <isNotEmpty prepend="," property="Checker">
		          [Checker]=#Checker#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="CheckDept">
        <isNotEmpty prepend="," property="CheckDept">
		          [CheckDept]=#CheckDept#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Result">
        <isNotEmpty prepend="," property="Result">
		          [Result]=#Result#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="State">
        <isNotEmpty prepend="," property="State">
		          [State]=#State#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Creator">
        <isNotEmpty prepend="," property="Creator">
		          [Creator]=#Creator#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="CreateDate">
        <isNotEmpty prepend="" property="CreateDate">
				  <isNotEqual prepend="," property="CreateDate" compareValue="1900-01-01">
		          [CreateDate]=#CreateDate#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="Updater">
        <isNotEmpty prepend="," property="Updater">
		          [Updater]=#Updater#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="UpdateDate">
        <isNotEmpty prepend="" property="UpdateDate">
				  <isNotEqual prepend="," property="UpdateDate" compareValue="1900-01-01">
		          [UpdateDate]=#UpdateDate#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="IsDelete">
        <isNotEmpty prepend="" property="IsDelete">
				  <isNotEqual prepend="," property="IsDelete" compareValue="0">
		          [IsDelete]=#IsDelete#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="CreatorCode">
        <isNotEmpty prepend="," property="CreatorCode">
		          [CreatorCode]=#CreatorCode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="UpdaterCode">
        <isNotEmpty prepend="," property="UpdaterCode">
		          [UpdaterCode]=#UpdaterCode#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	<isPropertyAvailable prepend="" property="OperDept">
        <isNotEmpty prepend="," property="OperDept">
		          [OperDept]=#OperDept#
		          </isNotEmpty>
      </isPropertyAvailable>	
	    	 </dynamic>
    </sql>
	<sql id="WhereConditions">
	 <dynamic prepend="WHERE">
	 	 <isPropertyAvailable prepend="" property="Id">
        <isNotEmpty prepend="AND" property="Id">
		          [Id]=#Id#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="CheckNo">
        <isNotEmpty prepend="AND" property="CheckNo">
		          [CheckNo]=#CheckNo#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="CheckType">
        <isNotEmpty prepend="AND" property="CheckType">
		          [CheckType]=#CheckType#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="StartDate">
        <isNotEmpty prepend="AND" property="StartDate">
		          [StartDate]=#StartDate#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="EndDate">
        <isNotEmpty prepend="AND" property="EndDate">
		          [EndDate]=#EndDate#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="InvCode">
        <isNotEmpty prepend="AND" property="InvCode">
		          [InvCode]=#InvCode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="BatchQty">
        <isNotEmpty prepend="AND" property="BatchQty">
		          [BatchQty]=#BatchQty#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="SampType">
        <isNotEmpty prepend="AND" property="SampType">
		          [SampType]=#SampType#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="CustSampCode">
        <isNotEmpty prepend="AND" property="CustSampCode">
		          [CustSampCode]=#CustSampCode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Percentage">
        <isNotEmpty prepend="" property="Percentage">
				  <isNotEqual prepend="AND" property="Percentage" compareValue="0">
		          [Percentage]=#Percentage#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="SampQty">
        <isNotEmpty prepend="" property="SampQty">
				  <isNotEqual prepend="AND" property="SampQty" compareValue="0">
		          [SampQty]=#SampQty#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="CheckLevel">
        <isNotEmpty prepend="AND" property="CheckLevel">
		          [CheckLevel]=#CheckLevel#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="StrictDegree">
        <isNotEmpty prepend="AND" property="StrictDegree">
		          [StrictDegree]=#StrictDegree#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="AQL">
        <isNotEmpty prepend="" property="AQL">
				  <isNotEqual prepend="AND" property="AQL" compareValue="0">
		          [AQL]=#AQL#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="RecQty">
        <isNotEmpty prepend="" property="RecQty">
				  <isNotEqual prepend="AND" property="RecQty" compareValue="((0))">
		          [RecQty]=#RecQty#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="RejectionQty">
        <isNotEmpty prepend="" property="RejectionQty">
				  <isNotEqual prepend="AND" property="RejectionQty" compareValue="((0))">
		          [RejectionQty]=#RejectionQty#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="MoCode">
        <isNotEmpty prepend="AND" property="MoCode">
		          [MoCode]=#MoCode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="MoSeq">
        <isNotEmpty prepend="AND" property="MoSeq">
		          [MoSeq]=#MoSeq#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="SchCode">
        <isNotEmpty prepend="AND" property="SchCode">
		          [SchCode]=#SchCode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="ProcCode">
        <isNotEmpty prepend="AND" property="ProcCode">
		          [ProcCode]=#ProcCode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="WorkNo">
        <isNotEmpty prepend="AND" property="WorkNo">
		          [WorkNo]=#WorkNo#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="ShiftCode">
        <isNotEmpty prepend="AND" property="ShiftCode">
		          [ShiftCode]=#ShiftCode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="IssNo">
        <isNotEmpty prepend="AND" property="IssNo">
		          [IssNo]=#IssNo#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="IssSeq">
        <isNotEmpty prepend="" property="IssSeq">
				  <isNotEqual prepend="AND" property="IssSeq" compareValue="0">
		          [IssSeq]=#IssSeq#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Remark">
        <isNotEmpty prepend="AND" property="Remark">
		          [Remark]=#Remark#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="QualifiedQty">
        <isNotEmpty prepend="" property="QualifiedQty">
				  <isNotEqual prepend="AND" property="QualifiedQty" compareValue="0">
		          [QualifiedQty]=#QualifiedQty#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="QualWh">
        <isNotEmpty prepend="AND" property="QualWh">
		          [QualWh]=#QualWh#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="ProcUnQty">
        <isNotEmpty prepend="" property="ProcUnQty">
				  <isNotEqual prepend="AND" property="ProcUnQty" compareValue="0">
		          [ProcUnQty]=#ProcUnQty#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="ProcUnWh">
        <isNotEmpty prepend="AND" property="ProcUnWh">
		          [ProcUnWh]=#ProcUnWh#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="IssUnQty">
        <isNotEmpty prepend="" property="IssUnQty">
				  <isNotEqual prepend="AND" property="IssUnQty" compareValue="0">
		          [IssUnQty]=#IssUnQty#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="IssUnWh">
        <isNotEmpty prepend="AND" property="IssUnWh">
		          [IssUnWh]=#IssUnWh#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="QualSampQty">
        <isNotEmpty prepend="" property="QualSampQty">
				  <isNotEqual prepend="AND" property="QualSampQty" compareValue="0">
		          [QualSampQty]=#QualSampQty#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="QualSampWh">
        <isNotEmpty prepend="AND" property="QualSampWh">
		          [QualSampWh]=#QualSampWh#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="UnQualSampQty">
        <isNotEmpty prepend="" property="UnQualSampQty">
				  <isNotEqual prepend="AND" property="UnQualSampQty" compareValue="0">
		          [UnQualSampQty]=#UnQualSampQty#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="UnQualSampWh">
        <isNotEmpty prepend="AND" property="UnQualSampWh">
		          [UnQualSampWh]=#UnQualSampWh#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Checker">
        <isNotEmpty prepend="AND" property="Checker">
		          [Checker]=#Checker#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="CheckDept">
        <isNotEmpty prepend="AND" property="CheckDept">
		          [CheckDept]=#CheckDept#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Result">
        <isNotEmpty prepend="AND" property="Result">
		          [Result]=#Result#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="State">
        <isNotEmpty prepend="AND" property="State">
		          [State]=#State#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Creator">
        <isNotEmpty prepend="AND" property="Creator">
		          [Creator]=#Creator#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="CreateDate">
        <isNotEmpty prepend="" property="CreateDate">
				  <isNotEqual prepend="AND" property="CreateDate" compareValue="1900-01-01">
		          [CreateDate]=#CreateDate#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Updater">
        <isNotEmpty prepend="AND" property="Updater">
		          [Updater]=#Updater#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="UpdateDate">
        <isNotEmpty prepend="" property="UpdateDate">
				  <isNotEqual prepend="AND" property="UpdateDate" compareValue="1900-01-01">
		          [UpdateDate]=#UpdateDate#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="IsDelete">
        <isNotEmpty prepend="" property="IsDelete">
				  <isNotEqual prepend="AND" property="IsDelete" compareValue="0">
		          [IsDelete]=#IsDelete#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="CreatorCode">
        <isNotEmpty prepend="AND" property="CreatorCode">
		          [CreatorCode]=#CreatorCode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="UpdaterCode">
        <isNotEmpty prepend="AND" property="UpdaterCode">
		          [UpdaterCode]=#UpdaterCode#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="OperDept">
        <isNotEmpty prepend="AND" property="OperDept">
		          [OperDept]=#OperDept#
		          </isNotEmpty>
      </isPropertyAvailable>
	  	 <isPropertyAvailable prepend="" property="Timestamp">
        <isNotEmpty prepend="" property="Timestamp">
				  <isNotEqual prepend="AND" property="Timestamp" compareValue="1900-01-01">
		          [Timestamp]=#Timestamp#
		  		  </isNotEqual>
		        </isNotEmpty>
      </isPropertyAvailable>
	  </dynamic> 
    </sql>
	<sql id="InsertPublic">
      INSERT INTO CheckListH(
	     <dynamic prepend=" ">
       	   <isPropertyAvailable prepend="" property="Id">
        <isNotEmpty prepend="," property="Id">
          [Id]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="CheckNo">
        <isNotEmpty prepend="," property="CheckNo">
          [CheckNo]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="CheckType">
        <isNotEmpty prepend="," property="CheckType">
          [CheckType]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="StartDate">
        <isNotEmpty prepend="," property="StartDate">
          [StartDate]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="EndDate">
        <isNotEmpty prepend="," property="EndDate">
          [EndDate]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="InvCode">
        <isNotEmpty prepend="," property="InvCode">
          [InvCode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="BatchQty">
        <isNotEmpty prepend="," property="BatchQty">
          [BatchQty]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="SampType">
        <isNotEmpty prepend="," property="SampType">
          [SampType]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="CustSampCode">
        <isNotEmpty prepend="," property="CustSampCode">
          [CustSampCode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Percentage">
        <isNotEmpty prepend="," property="Percentage">
          [Percentage]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="SampQty">
        <isNotEmpty prepend="," property="SampQty">
          [SampQty]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="CheckLevel">
        <isNotEmpty prepend="," property="CheckLevel">
          [CheckLevel]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="StrictDegree">
        <isNotEmpty prepend="," property="StrictDegree">
          [StrictDegree]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="AQL">
        <isNotEmpty prepend="," property="AQL">
          [AQL]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="RecQty">
        <isNotEmpty prepend="," property="RecQty">
          [RecQty]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="RejectionQty">
        <isNotEmpty prepend="," property="RejectionQty">
          [RejectionQty]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="MoCode">
        <isNotEmpty prepend="," property="MoCode">
          [MoCode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="MoSeq">
        <isNotEmpty prepend="," property="MoSeq">
          [MoSeq]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="SchCode">
        <isNotEmpty prepend="," property="SchCode">
          [SchCode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="ProcCode">
        <isNotEmpty prepend="," property="ProcCode">
          [ProcCode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="WorkNo">
        <isNotEmpty prepend="," property="WorkNo">
          [WorkNo]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="ShiftCode">
        <isNotEmpty prepend="," property="ShiftCode">
          [ShiftCode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="IssNo">
        <isNotEmpty prepend="," property="IssNo">
          [IssNo]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="IssSeq">
        <isNotEmpty prepend="," property="IssSeq">
          [IssSeq]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Remark">
        <isNotEmpty prepend="," property="Remark">
          [Remark]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="QualifiedQty">
        <isNotEmpty prepend="," property="QualifiedQty">
          [QualifiedQty]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="QualWh">
        <isNotEmpty prepend="," property="QualWh">
          [QualWh]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="ProcUnQty">
        <isNotEmpty prepend="," property="ProcUnQty">
          [ProcUnQty]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="ProcUnWh">
        <isNotEmpty prepend="," property="ProcUnWh">
          [ProcUnWh]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="IssUnQty">
        <isNotEmpty prepend="," property="IssUnQty">
          [IssUnQty]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="IssUnWh">
        <isNotEmpty prepend="," property="IssUnWh">
          [IssUnWh]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="QualSampQty">
        <isNotEmpty prepend="," property="QualSampQty">
          [QualSampQty]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="QualSampWh">
        <isNotEmpty prepend="," property="QualSampWh">
          [QualSampWh]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="UnQualSampQty">
        <isNotEmpty prepend="," property="UnQualSampQty">
          [UnQualSampQty]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="UnQualSampWh">
        <isNotEmpty prepend="," property="UnQualSampWh">
          [UnQualSampWh]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Checker">
        <isNotEmpty prepend="," property="Checker">
          [Checker]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="CheckDept">
        <isNotEmpty prepend="," property="CheckDept">
          [CheckDept]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Result">
        <isNotEmpty prepend="," property="Result">
          [Result]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="State">
        <isNotEmpty prepend="," property="State">
          [State]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Creator">
        <isNotEmpty prepend="," property="Creator">
          [Creator]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="CreateDate">
        <isNotEmpty prepend="," property="CreateDate">
          [CreateDate]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Updater">
        <isNotEmpty prepend="," property="Updater">
          [Updater]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="UpdateDate">
        <isNotEmpty prepend="," property="UpdateDate">
          [UpdateDate]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="IsDelete">
        <isNotEmpty prepend="," property="IsDelete">
          [IsDelete]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="CreatorCode">
        <isNotEmpty prepend="," property="CreatorCode">
          [CreatorCode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="UpdaterCode">
        <isNotEmpty prepend="," property="UpdaterCode">
          [UpdaterCode]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="OperDept">
        <isNotEmpty prepend="," property="OperDept">
          [OperDept]
        </isNotEmpty>
      </isPropertyAvailable>
	  	   <isPropertyAvailable prepend="" property="Timestamp">
        <isNotEmpty prepend="," property="Timestamp">
          [Timestamp]
        </isNotEmpty>
      </isPropertyAvailable>
	  </dynamic>
      )
      VALUES
      (
	   <dynamic prepend=" ">
      	<isPropertyAvailable prepend="" property="Id">
        <isNotEmpty prepend="," property="Id">		
         #Id#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="CheckNo">
        <isNotEmpty prepend="," property="CheckNo">		
         #CheckNo#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="CheckType">
        <isNotEmpty prepend="," property="CheckType">		
         #CheckType#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="StartDate">
        <isNotEmpty prepend="," property="StartDate">		
         #StartDate#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="EndDate">
        <isNotEmpty prepend="," property="EndDate">		
         #EndDate#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="InvCode">
        <isNotEmpty prepend="," property="InvCode">		
         #InvCode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="BatchQty">
        <isNotEmpty prepend="," property="BatchQty">		
         #BatchQty#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="SampType">
        <isNotEmpty prepend="," property="SampType">		
         #SampType#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="CustSampCode">
        <isNotEmpty prepend="," property="CustSampCode">		
         #CustSampCode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Percentage">
        <isNotEmpty prepend="," property="Percentage">		
         #Percentage#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="SampQty">
        <isNotEmpty prepend="," property="SampQty">		
         #SampQty#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="CheckLevel">
        <isNotEmpty prepend="," property="CheckLevel">		
         #CheckLevel#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="StrictDegree">
        <isNotEmpty prepend="," property="StrictDegree">		
         #StrictDegree#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="AQL">
        <isNotEmpty prepend="," property="AQL">		
         #AQL#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="RecQty">
        <isNotEmpty prepend="," property="RecQty">		
         #RecQty#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="RejectionQty">
        <isNotEmpty prepend="," property="RejectionQty">		
         #RejectionQty#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="MoCode">
        <isNotEmpty prepend="," property="MoCode">		
         #MoCode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="MoSeq">
        <isNotEmpty prepend="," property="MoSeq">		
         #MoSeq#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="SchCode">
        <isNotEmpty prepend="," property="SchCode">		
         #SchCode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="ProcCode">
        <isNotEmpty prepend="," property="ProcCode">		
         #ProcCode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="WorkNo">
        <isNotEmpty prepend="," property="WorkNo">		
         #WorkNo#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="ShiftCode">
        <isNotEmpty prepend="," property="ShiftCode">		
         #ShiftCode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="IssNo">
        <isNotEmpty prepend="," property="IssNo">		
         #IssNo#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="IssSeq">
        <isNotEmpty prepend="," property="IssSeq">		
         #IssSeq#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Remark">
        <isNotEmpty prepend="," property="Remark">		
         #Remark#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="QualifiedQty">
        <isNotEmpty prepend="," property="QualifiedQty">		
         #QualifiedQty#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="QualWh">
        <isNotEmpty prepend="," property="QualWh">		
         #QualWh#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="ProcUnQty">
        <isNotEmpty prepend="," property="ProcUnQty">		
         #ProcUnQty#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="ProcUnWh">
        <isNotEmpty prepend="," property="ProcUnWh">		
         #ProcUnWh#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="IssUnQty">
        <isNotEmpty prepend="," property="IssUnQty">		
         #IssUnQty#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="IssUnWh">
        <isNotEmpty prepend="," property="IssUnWh">		
         #IssUnWh#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="QualSampQty">
        <isNotEmpty prepend="," property="QualSampQty">		
         #QualSampQty#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="QualSampWh">
        <isNotEmpty prepend="," property="QualSampWh">		
         #QualSampWh#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="UnQualSampQty">
        <isNotEmpty prepend="," property="UnQualSampQty">		
         #UnQualSampQty#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="UnQualSampWh">
        <isNotEmpty prepend="," property="UnQualSampWh">		
         #UnQualSampWh#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Checker">
        <isNotEmpty prepend="," property="Checker">		
         #Checker#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="CheckDept">
        <isNotEmpty prepend="," property="CheckDept">		
         #CheckDept#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Result">
        <isNotEmpty prepend="," property="Result">		
         #Result#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="State">
        <isNotEmpty prepend="," property="State">		
         #State#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Creator">
        <isNotEmpty prepend="," property="Creator">		
         #Creator#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="CreateDate">
        <isNotEmpty prepend="," property="CreateDate">		
         #CreateDate#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Updater">
        <isNotEmpty prepend="," property="Updater">		
         #Updater#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="UpdateDate">
        <isNotEmpty prepend="," property="UpdateDate">		
         #UpdateDate#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="IsDelete">
        <isNotEmpty prepend="," property="IsDelete">		
         #IsDelete#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="CreatorCode">
        <isNotEmpty prepend="," property="CreatorCode">		
         #CreatorCode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="UpdaterCode">
        <isNotEmpty prepend="," property="UpdaterCode">		
         #UpdaterCode#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="OperDept">
        <isNotEmpty prepend="," property="OperDept">		
         #OperDept#		
        </isNotEmpty>
      </isPropertyAvailable>
	  	<isPropertyAvailable prepend="" property="Timestamp">
        <isNotEmpty prepend="," property="Timestamp">		
         #Timestamp#		
        </isNotEmpty>
      </isPropertyAvailable>
	  </dynamic>
      )
    </sql>
	<!-- Insert statement:新增Mapper-->
    <insert id='Insert' parameterClass='CheckListH'>
      <include refid="InsertPublic"/>
    </insert>
    <!--Update statement:修改Mapper-->
    <update id='Update' parameterClass='CheckListH'>
      UPDATE [CheckListH] 
      <include refid="UpdaterConditions"/>
      WHERE 1=1
	  	  AND CheckNo=#CheckNo#
	      </update>
    <update id='UpdateSetion' parameterClass='hashtable'>
      UPDATE [CheckListH] 
      <include refid="UpdaterConditions"/>
      WHERE $conditions$
    </update>
	<update id='Save' parameterClass='CheckListH'>
      IF NOT EXISTS(SELECT 1 FROM [CheckListH] WHERE 1=1  AND [CheckNo]=#CheckNo# )
      BEGIN
      <include refid="InsertPublic"/>
      END
      ELSE
      BEGIN
      UPDATE CheckListH 
      <include refid="UpdaterConditions"/>
      WHERE  1=1
	  	  AND [CheckNo]=#CheckNo#
	        END
    </update>
	<delete id='Delete' parameterClass='hashtable'>
      DELETE FROM [CheckListH] WHERE	  
        <![CDATA[  
	 [CheckNo]=#pk0# 
        ]]>
    </delete>
    <delete id='DeleteWhere' parameterClass='string'>
      DELETE FROM [CheckListH] WHERE $value$
    </delete>

    <!-- select by key statement:-->
    <select id='FindOne' parameterClass='hashtable' resultClass='CheckListH'>
      SELECT * FROM CheckListH WHERE      
        <![CDATA[
		[CheckNo]=#pk0# 
        ]]>
    </select>
    <select id='FindAllCondition' parameterClass='string' resultClass='CheckListH'>
      SELECT * FROM [CheckListH] WHERE $value$
    </select>
    <select id='FindScalar' parameterClass='hashtable' resultClass='CheckListH'>
      SELECT * FROM [CheckListH] WHERE $conditions$
    </select>
    
    <select id='FindAllCount' parameterClass='string' resultClass='int'>
      SELECT COUNT(1) FROM [CheckListH] WHERE $value$
    </select>
    <select id='FindByPage' parameterClass='string' resultClass='CheckListH'>
      SELECT * FROM [CheckListH] WHERE $value$
    </select>
  </statements>
</sqlMap>
